4.1 KB · ⇊ 3 parts · ⤓ Micron 4.1 KB · ⤓ HTML 26.1 KB

top

SQL:2003 is the fifth revision of the SQL database query language. The standard consists of 9 parts which are described in detail in SQL. It was updated by SQL:2006.

• New features

• Documentation availability

• References

• External links

The SQL:2003 standard makes minor modifications to all parts of SQL:1999 (also known as SQL3), and officially introduces a few new features such as:cite-ref-1[1]

• XML-related features (SQL/XML)

• Window functions

• the sequence generator, which allows standardized sequences

• two new column types: auto-generated values and identity-columns

• the new MERGE statement

• extensions to the CREATE TABLE statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"

• removal of the poorly implemented "BIT" and "BIT VARYING" data types

• OLAP capabilities (initially added in SQL:1999) were extended with a window function.cite-ref-jensenpedersen2010-2-0[2]

For details see.cite-ref-3[3]

The SQL standard is not freely available but may be purchased from ISO or ANSI. A late draft is available as a zip archive Archived 2016-03-30 at the Wayback Machine from Whitemarsh Information Systems Corporation. The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.

cite-note-11. ↑ citerefeisenberg2004Eisenberg, Andrew; et al. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record. 33 (1): 119–126. doi:10.1145/974121.974142. Archived from the original (pdf) on 2007-11-11. Retrieved 2007-08-14.

cite-note-jensenpedersen2010-22. ↑ citerefchristian-s-jensentorben-bach-pedersenchristian-thomsen2010Christian S. Jensen; Torben Bach Pedersen; Christian Thomsen (2010). Multidimensional Databases and Data Warehousing. Morgan & Claypool Publishers. p. 26. ISBN 978-1-60845-537-9.

cite-note-33. ↑ SQL:2003 Has Been Published

• BNF Grammar for ISO/IEC 9075:2003 – SQL/Framework